<?php
$db=new PDO("mysql:host=localhost", 'root', '12qwas');
$db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE,PDO::FETCH_ASSOC);
$db->exec('create database if not exists db');
$db->exec('use db');
$db->exec("create table if not exists students (xh varchar(9) not null primary key,name varchar(50), tel varchar(11), pwd varchar (20) default '12345')");
$r=$db->exec('delete from students');
echo "删除记录个数：{$r}条\n";
$r=$db->exec("insert into students(xh,name,tel) values
('213110601','张三','11111111222'),
('213110602','李四','22222222222'),
('213110603','王五','33333333333'),
('213110701','杨柳','44444444444')");
echo "插入 $ 条记录\n";
$ps=$db->query('select * from students ');//返回的结果集包含在$ps语句对象中
foreach ($ps as $row){
    echo "{$row['xh']}\t{$row['name']}\t{$row['tel']}\n";
}
`git config --global user.name "左薇颖"`;
`git config --global user.email "3047477309@qq.com"`;
